34/34

# Index

A B C D E F G H I J K L M N O P Q R S T U V W X

## Symbols

  %*
    put annotation, 5.4.1
  %annotation
    See annotations alphabetically by name
  %oracle-property annotations, 6
  %ora-java
    binding annotation, 5.4.4, 5.4.4
  %output annotation, 6
  %updating annotation, 5.4.1

## A

  access privileges, Oracle Database, 1.4.4
  adapters
    Avro, 6
    Oracle NoSQL Database, 6
    sequence file, 6
    text file, 6
    XML file, 6
  additional_path.txt file for ODI, 4.2.2
  aggregate function, 8.5.4
  aggregate functions for Hive, 8.5.4
  ALLOW_BACKSLASH_ESCAPING_ANY_CHARACTER property, 6
  ALLOW_COMMENTS property, 6
  ALLOW_NON_NUMERIC_NUMBERS property, 6
  ALLOW_NUMERIC_LEADING_ZEROS property, 6
  ALLOW_SINGLE_QUOTES property, 6
  ALLOW_UNQUOTED_CONTROL_CHARS property, 6
  ALLOW_UNQUOTED_FIELD_NAMES property, 6
  ALTER SESSION commands, 2.12
  analytic functions in R, 8.5.1
  analyze-string function, 5.4.2
  annotations
    Avro collection, 6
    equal to Oracle Loader for Hadoop configuration properties, 6
    for writing to Oracle NoSQL Database, 6
    Oracle Database adapter, 6
    Oracle NoSQL Database adapter, 6
    reading from Oracle NoSQL Database, 6
    reading sequence files, 6
    reading text files, 6
    reading XML files, 6
    writing text files, 6
    See also specific annotations by name
  Apache Hadoop distribution, 1.2.2, 1.4.1, 1.4.1, 1.5.1, 1.8.1.1
  Apache licenses, 3.15.1, 3.15.2, 3.15.3, 3.15.5
  APPEND hint, 2.12
  as.ore.* functions, 8.5.7
  avro
    compress annotation, 6
    file annotation, 6
    put annotation, 6
    schema annotation, 6
    schema-file annotation, 6
    schema-kv annotation, 6, 6, 6, 6
  Avro
    annotations for reading, 6
    annotations for writing, 6
  Avro array,
    reading as XML, 6
  Avro file adapter, 6
    examples, 6
    reading Avro as XML, 6
    writing XML as Avro, 6
  Avro files
    collection annotations, 6
    collection function, 6
    converting text to, 6
    functions for reading, 6
    output file name, 6
    put functions, 6
    querying records, 6
    reading, 6
    reading as XML, 6
    writing, 6
  Avro license, 3.15.2
  Avro maps, 6
  Avro maps, reading as XML, 6
  Avro null values, 6
  Avro primitives
    reading as XML, 6
  Avro reader schema, 6, 6, 6, 6
  Avro records, reading as XML, 6
  Avro unions, reading as XML, 6
  avro:collection-avroxml function, 6
  avro:get function, 6
  avroxml method, 6, 6

## B

  balancing loads in Oracle Loader for Hadoop, 3.12
  bashrc configuration file, 1.8.1.1
  batchSize property, 6, 6
  bzip2 input files, 2.11.2

## C

  CDH3 distribution, 1.5.1
  character encoding, 6, 6
  character methods for Hive, 8.3.3
  CKM Hive, 4.1.2, 4.5.2.2
  client libraries, 1.5.2
  clients
    configuring Hadoop, 1.4.2, 1.8.3.2
  coersing data types in R, 8.5.7
  collection annotation
    text files, 6
  collection annotations
    Avro, 6
  collection function (XQuery)
    description, 5.3
  collection functions
    Oracle NoSQL Database adapter, 6
    sequence files, 6
    text files, 6
  columnCount property (OSCH), 2.11.2
  columnLength property (OSCH), 2.11.2, 2.11.2
  columnNames property (OSCH), 2.11.2
  columnType property (OSCH), 2.11.2, 2.11.2, 2.11.2
  compressed data files, 2.11.2
  compressed files, 2.11.2
  compression
    data in database tables, 2.2
    sequence files, 6
  compression codec, 6
  compression methods
    Avro output files, 6
  CompressionCodec property (OSCH), 2.11.2
  configuration properties
    for Oracle XQuery for Hadoop, 6
    JSON file adapter, 6
    Oracle NoSQL Database adapter, 6
    Oracle XQuery for Hadoop, 5.7
  configuration settings
    Hadoop client, 1.4.2, 1.8.3.2
    Oracle Data Integrator agent, 4.2.4
    Oracle Data Integrator interfaces, 4.5
    Oracle Data Integrator Studio, 4.2.5
    Sqoop utility, 1.8.1.2
  configuring a Hadoop client, 1.4.2, 1.8.3.2
  connecting to Oracle Database from R, 8.5.5
  consistency property, 6, 6
  CREATE SESSION privilege, 1.4.4
  CREATE TABLE
    configuration properties, 7.4.2
    examples, 7.4.3
    syntax, 7.4.1
  CREATE TABLE privilege, 1.4.4
  CREATE_TARG_TABLE option, 4.5.1, 4.5.2.1, 4.5.2.3, 4.5.3
  CSV files, 2.11.2, 3.14

## D

  data integrity checking, 4.5.2.2
  Data Pump files, 2.6.2
    XML template, 2.6.2.3, 2.6.2.3
  data sources
    defining for Oracle Data Integrator, 4.2.1
  data transformations, 4.5.2.3
  data type mappings
    between XQuery and Avro, 6
    between XQuery and Oracle Database, 6
    Oracle Database and XQuery, 6
  data type mappings, Hive (OSCH), 2.11.2
  data type testing in R, 8.5.7
  data types
    Oracle Loader for Hadoop, 3.4.1
  data validation in Oracle Data Integrator, 4.1.2, 4.5.2.3
  database directories
    for Oracle SQL Connector for HDFS, 1.4.3
  database patches, 1.4.1, 1.5.1, 1.5.1, 2.6.2
  database privileges, 1.4.4
  database system, configuring to run MapReduce jobs, 1.4.2
  database tables
    writing using Oracle XQuery for Hadoop, 6
  databaseName property, Hive (OSCH), 2.11.2
  dataCompressionCodec property (OSCH), 2.11.2
  dataPathFilter property (OSCH), 2.11.2
  dataPaths property (OSCH), 2.11.2
  DataServer objects
    creating for Oracle Data Integrator, 4.2.1
  dateMask property (OSCH), 2.11.2, 2.11.2
  defaultDirectory property (OSCH), 2.11.2
  DEFER_TARGET_LOAD option, 4.5.1
  deflate compression, 6
  DELETE_ALL option, 4.5.3
  DELETE_TEMPORARY_OBJECTS option, 4.5.1, 4.5.2.1, 4.5.2.3, 4.5.3
  delimited text files
    XML templates, 2.6.5.4
  DelimitedTextInputFormat class, 3.7.1, 3.14, 3.14
    Oracle Loader for Hadoop, 3.7.1.3
  DelimitedTextOutputFormat class, 3.14
  delimiter
    for splitting text files, 6
  Direct Connector for HDFS
    See SQL Connector for HDFS
  directories
    accessible by Oracle Data Integrator, 4.2.1
    default HDFS for XQuery, 5.7
    for Oracle Loader for Hadoop output, 4.5.3
    ODI Application Adapter for Hadoop home, 1.6.3
    Oracle SQL Connector for HDFS home, 1.4.3
    Sqoop home, 1.8.1.2
    See also database directories; root directory
  Directory property (OSCH), 2.11.2
  disable_directory_link_check access parameter, 2.6.2
  distributed cache
    accessing from Oracle XQuery for Hadoop, 5.4.3
  downloading software, 1.3, 1.4.1, 1.6.1, 1.8.1.1, 1.8.1.2, 1.8.1.4, 1.8.3.4
  drivers
    JDBC, 1.8.1.2, 3.9.1.1, 4.2.2
    Oracle Data Integrator agent, 4.2.4
    ORACLE_DATAPUMP, 3.9.4.1
    ORACLE_LOADER, 2.10, 2.10
  DROP_ERROR_TABLE option, 4.5.2.2
  durability property, 6

## E

  encoding characters, 6, 6
  error logging for Oracle XQuery for Hadoop, 5.7
  exponential functions (XQuery), 5.4.2
  EXT_TAB_DIR_LOCATION option, 4.5.3
  external tables
    about, 2.1
  EXTERNAL VARIABLE DATA access parameter, 2.6.2
  EXTERNAL_TABLE option, 4.5.1
  ExternalTable command
    syntax, 2.5.2
  EXTRA_OLH_CONF_PROPERTIES option, 4.5.3

## F

  fieldLength property (OSCH), 2.11.2, 2.11.2
  fieldTerminator property (OSCH), 2.11.2
  file formats for Oracle Data Integrator, 4.5.1
  file paths
    locating in XQuery, 6
  file sources
    defining for Oracle Data Integrator, 4.2.1
  File to Hive KM, 4.1.2, 4.5.1
  FILE_IS_LOCAL option, 4.5.1
  File-Hive to Oracle (OLH) KM, 4.1.2, 4.5.3
  fivenum function, 8.5.4
  flex fields, 4.2.2, 4.4.2
  FLOW_CONTROL option, 4.5.2.1
  FLOW_TABLE_OPTIONS option, 4.5.3
  FLWOR requirements, 5.4.1
  fn
    nilled function, 6, 6
  fn functions, 5.4.2
  frame methods for Hive, 8.3.3
  functions
    for writing to Oracle NoSQL Database, 6
    Oracle NoSQL Database, 6
    reading and writing sequence files, 6
    reading and writing text files, 6
    reading Avro files, 6
    reading from Oracle NoSQL Database, 6, 6
    reading JSON files, 6
    reading sequence files, 6
    reading text files, 6
    reading XML files, 6, 6
    writing Avro files, 6
    writing sequence files, 6
    writing text files, 6

## G

  get function
    Oracle NoSQL Database adapter, 6
  gzip input files, 2.11.2

## H

  Hadoop client
    configuring, 1.4.2, 1.8.3.2
    installing, 1.4.2
  HADOOP_CLASSPATH
    for Oracle Data Integrator, 4.2.4, 4.2.4
  HADOOP_HOME
    for Oracle Data Integrator, 4.2.4
  HADOOP_HOME environment variable, 1.8.1.1
  HADOOP_LIBEXEC_DIR environment variable, 1.8.1.1
  hadoop.exec function, 8.5.8
  hadoop.jobs function, 8.5.8
  hadoop.run function, 8.5.8
  HDFS client
    See Hadoop client
  HDFS commands
    issuing from R, 8.5.2
  HDFS data
    copying in R, 8.5.6
  hdfs dfs command, 1.4.2
  HDFS directories
    creating in R, 8.5.2
  HDFS directory, 5.7
  HDFS files
    copying into Hive, 4.5.1
    loading data into an Oracle database, 3.7.6
    restrictions in Oracle R Advanced Analytics for Hadoop, 8.2
  hdfs_stream Bash shell script, 1.4.3
  hdfs.attach function, 8.5.6
  hdfs.cd function, 8.5.2
  hdfs.cp function, 8.5.2
  hdfs.describe function, 8.5.2
  hdfs.download function, 8.5.6
  hdfs.exists function, 8.5.2
  hdfs.fromHive function, 8.5.3
  hdfs.get function, 8.5.6
  hdfs.head function, 8.5.2
  hdfs.id function, 8.5.2
  hdfs.ls function, 8.5.2
  hdfs.mkdir function, 8.5.2
  hdfs.mv function, 8.5.2
  hdfs.parts function, 8.5.2
  hdfs.pull function, 8.5.6
  hdfs.push function, 8.5.6
  hdfs.put function, 8.5.6
  hdfs.pwd function, 8.5.2
  hdfs.rm function, 8.5.2
  hdfs.rmdir function, 8.5.2
  hdfs.root function, 8.5.2
  hdfs.sample function, 8.5.6
  hdfs.setroot function, 8.5.2
  hdfs.size function, 8.5.2
  hdfs.tail function, 8.5.2
  hdfs.toHive function, 8.5.3
  hdfs.upload function, 8.5.6
  hints for optimizing queries, 2.12
  Hive access from R, 8.3
  Hive access in R, 8.5.3
  Hive application adapters, 4.1.2, 4.5.2.2
  Hive Control Append KM, 4.1.2, 4.5.2.1
  Hive data source for Oracle Data Integrator, 4.2.2
  Hive data type mappings (OSCH), 2.11.2
  Hive data types, support for, 8.3.4
  Hive database for Oracle Loader for Hadoop, 1.5.1
  Hive distribution, 1.5.1
  Hive flex fields, 4.4.2
  Hive JAR files for Oracle Loader for Hadoop, 3.10.1
  Hive Query Language (HiveQL), 4.1.1
  Hive tables
    loading data into (Oracle Data Integrator), 4.5.1
    reverse engineering, 4.1.2, 4.4.2
    reverse engineering in Oracle Data Integrator, 4.4.2
    XML format, 2.6.3.5
  Hive Transform KM, 4.1.2, 4.5.2.3
  HIVE_HOME, for Oracle Data Integrator, 4.2.4
  hive.columnType property (OSCH), 2.11.2
  hive.databaseName property (OSCH), 2.11.2
  HiveToAvroInputFormat class, 3.7.3, 3.10.1
  hosts property, 6

## I

  IKM File to Hive, 4.1.2, 4.5.1, 4.5.1
  IKM File-Hive to Oracle (OLH), 4.1.2, 4.5.3
  IKM Hive Control Append, 4.1.2, 4.5.2.1, 4.5.2.1, 4.5.2.3
  IKM Hive Transform, 4.1.2, 4.5.2.1, 4.5.2.3
  IndexedRecord, 3.8.1
  InputFormat class
    Oracle Loader for Hadoop, 3.7.1.3
  INSERT_UPDATE mode, 4.2.2
  installation
    Apache Hadoop, 1.4.2
    CDH, 1.4.2
    Hadoop client, 1.4.2
    Oracle Data Integrator Application Adapter for Hadoop, 1.6
    Oracle Loader for Hadoop, 1.5
    Oracle R Advanced Analytics for Hadoop, 1.8
    Oracle SQL Connector for HDFS, 1.4
    Sqoop utility, 1.8.1.2
  installation instructions, 1
  Instant Client libraries, 1.5.2
  interface configurations
    Oracle Data Integrator, 4.5
  interquartile range, 8.5.4
  IQR function, 8.5.4
  is.hdfs.id function, 8.5.6
  is.ore.* functions, 8.5.7

## J

  JDBC drivers, 1.8.1.2, 3.9.1.1, 4.2.2
  json
    get function, 6
    parse-as-xml function, 6
  JSON data formats
    converting to XML, 6
  JSON file adapter
    configuration properties, 6
  JSON files
    reading, 6
  JSON module, 6
    examples, 6

## K

  knowledge modules
    description, 4.1.2
    See also CKM, IKM, and RKM entries
  kv
    collection annotation, 6
    collection-avroxml function, 6
    collection-binxml function, 6
    collection-text function, 6
    collection-xml function, 6
    get annotation, 6
    get-avroxml function, 6
    get-binxml function, 6
    get-text function, 6
    get-xml function, 6
    key annotation, 6, 6
    key-range function, 6, 6
    put annotation, 6
    put-binxml function, 6
    put-text function, 6
    put-xml function, 6
  KVAvroInputFormat class, 3.10.2
  kv.hosts property, 6
  kv.kvstore property, 6
  kvstore property, 6, 6

## L

  licenses, 5.8
  licenses, third-party, 3.15
  load balancing
    in Oracle Loader for Hadoop, 3.12, 3.12
  loadCI, 3.12.2
  loading data files into Hive, 4.5.1
  loading options for Oracle Data Integrator, 4.5.1
  local files
    copying into Hive, 4.5.1
  LOG_FILE_NAME option, 4.4.2
  log4j.logger.oracle.hadoop.xquery property, 5.7
  logical methods for Hive, 8.3.3

## M

  mapping
    JSON to XML, 6
  mappings
    Oracle Database and XQuery data types, 6
  mappings, Hive to Oracle Database (OSCH), 2.11.2
  MAPRED_OUTPUT_BASE_DIR option, 4.5.3
  MapReduce functions
    writing in R, 8.5.8
  MasterPolicy durability, 6
  matrix methods for Hive, 8.3.3
  maxLoadFactor property, 3.12.2
  median function, 8.5.4

## N

  nilled elements, 6
  nilled function, 6
  null values in Avro, 6
  numeric methods for Hive, 8.3.3

## O

  OCI Direct Path, 3.14
  ODI_ADDITIONAL_CLASSPATH environment variable, 4.2.4
  ODI_HIVE_SESSION_JARS, for Oracle Data Integrator, 4.2.4, 4.2.4
  ODI_OLH_JARS, for Oracle Data Integrator, 4.2.4
  OLH_HOME environment variable, 1.5.2, 1.5.3, 1.7.2, 4.2.4
  OLH_OUTPUT_MODE option, 4.5.3
  operating system user permissions, 1.4.3
  oracle
    columns annotation, 6
    put annotation, 6
  Oracle Data Integrator agent
    configuring, 4.2.4
    drivers, 4.2.4
  Oracle Data Integrator Application Adapter
    description, 4.1
  Oracle Data Integrator Application Adapter for Hadoop
    creating models, 4.4.1
    data sources, 4.2.1
    flex fields, 4.4.2
    installing, 1.6
    loading options, 4.5.1
    security, 4.1.3
    setting up projects, 4.3
    topology setup, 4.2
  Oracle Data Integrator Companion CD, 1.6.3
  Oracle Data Integrator Studio configuration, 4.2.5
  Oracle Database
    annotations for writing, 6
    connecting from R, 8.5.5
    put function, 6
    user privileges, 1.4.4
  Oracle Database access from ORCH, 8.4
  Oracle Database adapter, 6
    configuration properties, 6
    examples, 6
  Oracle Database Adapter
    using Oracle Loader for Hadoop, 6
  Oracle Direct Connector for HDFS
    See Oracle SQL Connector for HDFS
  Oracle Exadata Database Machine
    installing a Hadoop client, 1.4.2
  Oracle Instant Client libraries, 1.5.2
  Oracle Loader for Hadoop
    description, 3.1
    input formats, 3.7.6
    installing, 1.5
    supported database versions, 1.5.1
    using in Oracle Data Integrator, 4.1.2, 4.2.4, 4.5.3
  Oracle NoSQL Database
    annotations for writing, 6
  Oracle NoSQL Database adapter, 6
    annotations for reading, 6
    collection function, 6
    get function, 6
    reading Avro as XML, 6
    writing XML as Avro, 6
  Oracle NoSQL Database Adapter
    configuration properties, 6
    examples, 6
  Oracle NoSQL Database functions, 6
  Oracle OCI Direct Path, 3.14, 3.14
  Oracle permissions, 1.4.3
  Oracle R Advanced Analytics for Hadoop
    categorical list of functions, 8.5
    connecting to Oracle Database, 8.5.5
    copying HDFS data, 8.5.6
    debugging functions, 8.5.9
    description, 1.1, 8.1.2
    HDFS commands issued from, 8.5.2
    installation, 1.8
    MapReduce functions, 8.5.8
  Oracle RAC systems, installing a Hadoop client, 1.4.2
  Oracle Software Delivery Cloud, 1.3
  Oracle SQL Connector for HDFS
    description, 2.1
    installation, 1.4
    pattern-matching characters, 2.11.2
    query optimization, 2.12
  Oracle Technology Network
    certifications, 1.6.1
    downloads, 1.3, 1.8.1.2
  Oracle XQuery for Hadoop, 5
    accessing the distributed cache, 5.4.3
    accessing user-defined XQuery library modules and XML schemas, 5.4.5
    basic transformation examples, 5.4.6
    calling custom Java external functions, 5.4.4
    configuration properties, 5.7
    configuring Oracle NoSQL Database server, 6
    description, 5.1
    error logging levels, 5.7
    error recovery setting, 5.7
    hadoop command, 5.5
    JSON module, 6
    Oracle NoSQL Database adapter, 6
    output directory, 5.7
    running queries, 5.5
    running queries locally, 5.5.3
    sequence file adapter, 6
    temp directory, 5.7
    text file adapter, 6
    time zone, 5.7
    XML file adapter, 6
  Oracle XQuery for Hadoop adapters
    overview, 5.3.1
  Oracle XQuery for Hadoop modules
    overview, 5.3.2
  ORACLE_DATAPUMP driver, 3.9.4.1
  ORACLE_LOADER driver, 2.10, 2.10
  oracle.hadoop.loader.logBadRecords property, 3.11.1
  oracle.hadoop.loader.rejectLimit property, 3.11.2
  oracle.hadoop.loader.sampler.enableSampling property, 3.12.1
  oracle.hadoop.xquery.* properties, 5.7
  oracle.hadoop.xquery.json.parser.*
    See individual properties by name
  oracle.hadoop.xquery.kv.config.durability property, 6
  oracle.hadoop.xquery.kv.config.requestLimit property, 6
  oracle.hadoop.xquery.kv.config.requestTimeout property, 6
  oracle.hadoop.xquery.kv.config.socketOpenTimeout property, 6
  oracle.hadoop.xquery.kv.config.socketReadTimeout property, 6
  oracle.hadoop.xquery.lib.share property, 5.7
  oracle.kv.batchSize property, 6
  oracle.kv.consistency property, 6
  oracle.kv.hosts configuration property, 6
  oracle.kv.hosts property, 6, 6
  oracle.kv.kvstore configuration property, 6
  oracle.kv.kvstore property, 6, 6
  oracle.kv.timeout property, 6
  oracle-property annotation, 6
  orahdfs-version/bin directory, 1.4.3
  orahdfs-version.zip file, 1.4.3
  ora-java
    binding annotation, 5.4.4, 5.4.4
  OraLoader, 3.10, 3.14
  OraLoaderMetadata utility program, 3.6.2
  oraloader-version directory, 1.5.2, 1.7.2
  oraloader-version.zip file, 1.4.3, 1.5.2, 1.5.3, 1.7.2
  ORCH package
    installation, 1.8.1.1, 1.8.1.5
  ORCH package version, 8.5.9
  orch.connect function, 8.5.5
  orch.connected function, 8.5.5
  orch.cor function, 8.5.1
  orch.cov function, 8.5.1
  orch.create.parttab function, 8.5.8
  orch.dbcon function, 8.5.5
  orch.dbg.lasterr function, 8.5.9
  orch.dbg.on/off function, 8.5.9
  orch.dbg.output function, 8.5.9
  orch.dbinfo function, 8.5.5
  orch.debug function, 8.5.9
  orch.disconnect function, 8.5.5
  orch.dryrun function, 8.5.8
  orch.export function, 8.5.8
  orch.getXlevels function, 8.5.1
  orch.glm function, 8.5.1
  orch.keyval function, 8.5.8
  orch.keyvals function, 8.5.8
  orch.kmeans function, 8.5.1
  orch.lm function, 8.5.1
  orch.lmf function, 8.5.1
  orch.neural function, 8.5.1
  orch.nmf function, 8.5.1
  orch.nmf.NMFalgo function, 8.5.1
  orch.pack functions, 8.5.8
  orch.princomp function, 8.5.1
  orch.recommend function, 8.5.1
  orch.reconnect function, 8.5.5
  orch.tempPath function, 8.5.8
  orch.tgz package, 1.8.1.5
  orch.unpack function, 8.5.8
  orch.version function, 8.5.9
  ORE functions for Hive, 8.3.2
  ore.create function, 8.3.5, 8.5.3
  ore.drop function, 8.5.3
  ore.exec function, 8.3.5
  ore.get function, 8.5.3
  ore.pull function, 8.5.3
  ore.push function, 8.5.3
  ore.recode function, 8.5.3
  ore.warn.order option, 8.3.5
  OSCH_BIN_PATH directory, 1.4.4
  output
    encoding annotation, 6, 6, 6, 6
  output annotation, 6, 6
  output directory for Oracle XQuery for Hadoop, 5.7
  OVERRIDE_INPUTFORMAT option, 4.5.3
  OVERRIDE_ROW_FORMAT option, 4.5.1
  oxh
    find function, 6
    increment-counter function, 6
    println function, 6
    println-xml function, 6
    property function, 6
  oxh utility, 5.5
  oxh-charset property, 7.4.2
  oxh-column property, 7.4.2
  oxh-default-namespace property, 7.4.2
  oxh-elements property, 7.4.2
  oxh-entity.name property, 7.4.2
  oxh-namespace.prefix property, 7.4.2
  OXMLSerDe, 7.4.1

## P

  parallel processing, 1.2.1, 2.12
  parse-xml function, 5.4.2
  parsing options for JSON files, 6
  partitioning, 3.4.2
  PathFilter property (OSCH), 2.11.2
  Paths property (OSCH), 2.11.2
  pattern matching, 5.7
  pattern matching (OSCH), 2.11.2
  pattern-matching characters in Oracle SQL Connector for HDFS, 2.11.2
  POST_TRANSFORM_DISTRIBUTE option, 4.5.2.3
  POST_TRANSFORM_SORT option, 4.5.2.3
  PQ_DISTRIBUTE hint, 2.12
  PRE_TRANSFORM_DISTRIBUTE option, 4.5.2.3
  PRE_TRANSFORM_SORT option, 4.5.2.3
  preprocessor access parameter, 2.6.2
  privileges, Oracle Database, 1.4.4
  projects
    setting up in Oracle Data Integrator, 4.3
  put function (XQuery)
    description, 5.3
  put functions
    Oracle NoSQL Database adapter, 6
    sequence files, 6
    text files, 6

## Q

  quantile function, 8.5.4
  queries
    running in Oracle XQuery for Hadoop, 5.5
    running locally in Oracle XQuery for Hadoop, 5.5.3
  query optimization for Oracle SQL Connector for HDFS, 2.12

## R

  R data types, converting and testing, 8.5.7
  R distribution, 1.8.1.1, 1.8.3.1
  R Distribution, 1.8.1.4, 1.8.3.4
  R functions
    categorical listing, 8.5
  R functions for Hive, 8.3.3
  random order messages, 8.3.5
  reading Avro files, 6
  reading sequence files, 6
  reading text files, 6
  records, rejected, 3.11.2
  RECYCLE_ERRORS option, 4.5.2.1
  rejected records, 3.11.2
  ReplicaAck policy, 6
  ReplicaPolicy durability, 6
  requestLimit property, 6
  requestTimeout property, 6, 6
  reverse engineering in Hive, 4.1.2, 4.4.2
  reverse-engineering Hive tables, 4.4.2
  reverse.log file, 4.4.2
  RKM Hive, 4.1.2, 4.4.2

## S

  sampling data
    from Oracle Loader for Hadoop, 3.12.1
  scripts
    debugging in R, 8.5.9
    snippets, 4.1.1
  sd function, 8.5.4
  seq
    collection annotation, 6
    collection function, 6
    collection-binxml function, 6
    collection-xml function, 6
    compress annotation, 6
    file annotation, 6
    key annotation, 6
    put annotation, 6
    put functions, 6
    put-binxml function, 6
    put-xml function, 6
    split-max annotation, 6
    split-min annotation, 6
  sequence file adapter, 6
    annotations for writing, 6
    collection function, 6
    examples, 6
  sequence file adapter functions, 6
  sequence files
    compression, 6
    output file name, 6
    reading, 6
    split size, 6
    writing, 6
  SerDes JAR files, 4.2.4, 4.2.4
  serialization parameter, 6, 6
  serialization parameters, 6
  serialize function, 5.4.2
  skiperrors property for Oracle XQuery for Hadoop, 5.7
  skiperrors.counters property, 5.7
  skiperrors.log.max property, 5.7
  skiperrors.max property, 5.7
  snappy compression, 6
  snippets in Oracle Data Integrator, 4.1.1
  socketOpenTimeout property, 6
  socketReadTimeout property, 6
  software downloads, 1.3, 1.4.1, 1.6.1, 1.8.1.1, 1.8.1.2, 1.8.1.4, 1.8.3.4
  split size
    for Avro files, 6
    sequence files, 6
    text files, 6
  split sizes, 6
  splitting XML files, 6
  SQL*Loader, 3.9.3.1
  Sqoop, 8.4.1
  Sqoop utility
    installing on a Hadoop client, 1.8.3.3
    installing on a Hadoop cluster, 1.8.1.2
  standard deviation, 8.5.4
  STATIC_CONTROL option, 4.5.2.1
  STOP_ON_FILE_NOT_FOUND option, 4.5.1
  subrange specification, Oracle NoSQL Database adapter, 6

## T

  tables
    compression in database, 2.2
    copying data from HDFS, 3.1
    writing to Oracle Database, 6
  temp directory, setting for Oracle XQuery for Hadoop, 5.7
  TEMP_DIR option, 4.5.3
  text
    collection annotation, 6
    collection function, 6
    collection-xml function, 6
    compress annotation, 6
    file annotation, 6
    put annotation, 6
    put function, 6
    put-xml function, 6
    split annotation, 6
    split-max annotation, 6
    trace function, 6
  text file adapter, 6
    collection function, 6
    put function, 6
  text files
    converting to Avro, 6
    delimiter, 6
    reading, 6
    reading and writing, 6
    split size, 6
    writing, 6
  third-party licenses, 3.15, 5.8
  time zones in XQuery, 6
  timeout property, 6, 6
  timestampMask property (OSCH), 2.11.2, 2.11.2
  timestampTZMask property (OSCH), 2.11.2, 2.11.2
  timezone property for Oracle XQuery for Hadoop, 5.7
  TRANSFORM_SCRIPT option, 4.5.2.3
  TRANSFORM_SCRIPT_NAME option, 4.5.2.3
  transforming data
    in Oracle Data Integrator, 4.1, 4.5.2.1
  trignonometric functions (XQuery), 5.4.2
  TRUNCATE option, 4.5.1, 4.5.2.1, 4.5.3
  Tukey’s five-number summary, 8.5.4
  type mappings
    between XQuery and Avro, 6
    between XQuery and Oracle Database, 6

## U

  uncompressed files, 2.11.2
  unparsed-text function, 5.4.2, 5.4.3
  unparsed-text-available function, 5.4.2
  unparsed-text-lines function, 5.4.3
  unparsed-text-lines functions, 5.4.2
  updating functions, 5.4.1, 5.4.1
  USE_HIVE_STAGING_TABLE option, 4.5.3
  USE_LOG option, 4.4.2
  USE_ORACLE_STAGING_TABLE option, 4.5.3
  USE_STAGING_TABLE option, 4.5.1
  userlib directory, 4.2.5
  UTF-8 encoding, 6, 6
  UTL_FILE package, 1.4.4

## V

  validating data
    in Oracle Data Integrator, 4.1, 4.1.2, 4.5.2.1
  var function, 8.5.4
  variance calculation, 8.5.4
  vector methods for Hive, 8.3.3
  version, R software, 8.5.9

## W

  wildcard characters
    in resource names, 4.5.1
    setting up data sources in ODI using, 4.2.1
    support in IKM File To Hive (Load Data), 4.1.2
  wildcards, 5.7
  writing Avro files, 6
  writing sequence files, 6
  writing text files, 6
  writing to Oracle tables, 6

## X

  XML
    writing as Avro arrays, 6
    writing as Avro maps, 6
    writing as Avro primitives, 6
    writing as Avro records, 6
    writing as Avro unions, 6
  XML file adapter, 6
    examples, 6
  XML files
    reading, 6, 6
    restrictions on splitting, 6
  XML schemas
    accessing user-defined, 5.4.5
  XML template for Data Pump files, 2.6.2.3
  XML templates
    Data Pump files, 2.6.2.3
    delimited text files, 2.6.5.4
    Hive tables, 2.6.3.5
  XML_EXISTS function, 7.4.3.3
  XML_QUERY function, 7.4.3.3
  XML_QUERY_AS_primitive function, 7.4.3.3
  XML_TABLE function, 7.4.3.3
  xmlf
    collection annotation, 6
    collection functions, 6
    split annotation, 6
    split-entity annotation, 6
    split-max annotation, 6
    split-min annotation, 6, 6
    split-namespace annotation, 6
  xml-reference directory, 1.6.3, 4.2.2
  XQuery
    See Oracle XQuery for Hadoop
  XQuery library modules
    accessing user-defined, 5.4.5
  XQuery specification support, 5.4.2
  XQuery transformations
    requirements, 5.4.1
  xquery.output property, 5.7
  xquery.scratch property, 5.7
  xquery.skiperrors property, 5.7
  xquery.skiperrors.counters property, 5.7
  xquery.skiperrors.log.max property, 5.7
  xquery.skiperrors.max property, 5.7
  xquery.timezone property, 5.7
  xsi
    nil attribute, 6